Check Table checks a table or tables for errors. Currently, MySQL supports checking only for MyISAM, InnoDB and ARCHIVE tables. For MyISAM tables, the key statistics are updated as well.
Hint: Just simply control-click the table and select Maintain Table -> Check Table.The other check options that can be given are shown in the following table:
Type |
Meaning |
QUICK | Don't scan the rows to check for wrong links. |
FAST | Don't scan the rows to check for wrong links. |
CHANGED | Only check tables which have been changed since last check or haven't been closed properly. |
EXTENDED | Do a full key lookup for all keys for each row. This ensures that the table is 100 % consistent, but will take a long time! |
Related topics:
Analyze Table
Optimize Table
Repair Table